Trajectory Analysis

Explanation about coordinate system:

The coordinates of player are extracted from the unity component “Transform” Example in unity

The coordinate origin and coordinate system are shown in the figure:Example in unity

Recording frequency: Every 0.5 second.

Data preprocess:

1. copy the raw data to a new “workfiles” folder

library(tidyverse)
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr     1.1.2     ✔ readr     2.1.4
## ✔ forcats   1.0.0     ✔ stringr   1.5.0
## ✔ ggplot2   3.4.2     ✔ tibble    3.2.1
## ✔ lubridate 1.9.2     ✔ tidyr     1.3.0
## ✔ purrr     1.0.1     
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag()    masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
library(fs)

# Define the folder paths
log_folder <- "log_files"
working_folder <- "workfiles"

# Create the working folder if it doesn't exist
dir_create(working_folder)

# Copy files from log_files to the working folder
files_to_copy <- dir_ls(log_folder)
for (file in files_to_copy) {
  file_copy(file, file.path(working_folder, basename(file)))
}

2. Clean_up the data

# for participant 17 s3t3, there were 3 taskaccpeted because the participant set the wrong destination 2 times, should delete two meaningfulless taskaccepted(Found that also duplicated setNavitaion, but it will not cause influence to the results)

data <- read.csv("workfiles/participant_17_scenario_3_s_at_2023.09.28_11.33.58.csv", sep = ";")

taskAccept_indices <- which(data$taskState == "taskAccepted")
indices_to_replace <- taskAccept_indices[4:5]
# Replace "taskAccept" with empty string ("")
data$taskState[indices_to_replace] <- ""  

# Write the modified data back to the CSV file
write.table(data, file = "workfiles/participant_17_scenario_3_s_at_2023.09.28_11.33.58.csv", sep = ";", row.names = FALSE, col.names = TRUE, quote = FALSE)

##### same as 27 s1t3
data <- read.csv("workfiles/participant_27_scenario_1_w_at_2023.10.04_16.40.08.csv", sep = ";")

taskAccept_indices <- which(data$taskState == "taskAccepted")
indices_to_replace <- taskAccept_indices[4]
data$taskState[indices_to_replace] <- ""  

write.table(data, file = "workfiles/participant_27_scenario_1_w_at_2023.10.04_16.40.08.csv", sep = ";", row.names = FALSE, col.names = TRUE, quote = FALSE)

##### same as 27 s3t3
data <- read.csv("workfiles/participant_27_scenario_3_e_at_2023.10.04_16.15.54.csv", sep = ";")

taskAccept_indices <- which(data$taskState == "taskAccepted")
indices_to_replace <- taskAccept_indices[4]
data$taskState[indices_to_replace] <- ""  

write.table(data, file = "workfiles/participant_27_scenario_3_e_at_2023.10.04_16.15.54.csv", sep = ";", row.names = FALSE, col.names = TRUE, quote = FALSE)

##### same as 38 s3t1
data <- read.csv("workfiles/participant_38_scenario_3_w_at_2023.10.11_16.40.07.csv", sep = ";")

taskAccept_indices <- which(data$taskState == "taskAccepted")
indices_to_replace <- taskAccept_indices[2]
data$taskState[indices_to_replace] <- ""  

write.table(data, file = "workfiles/participant_38_scenario_3_w_at_2023.10.11_16.40.07.csv", sep = ";", row.names = FALSE, col.names = TRUE, quote = FALSE)

##### same as 44 s1t4
data <- read.csv("workfiles/participant_44_scenario_1_s_at_2023.10.13_16.29.40.csv", sep = ";")

taskAccept_indices <- which(data$taskState == "taskAccepted")
indices_to_replace <- taskAccept_indices[5]
data$taskState[indices_to_replace] <- ""  

write.table(data, file = "workfiles/participant_44_scenario_1_s_at_2023.10.13_16.29.40.csv", sep = ";", row.names = FALSE, col.names = TRUE, quote = FALSE)

##### same as 45 s3t3
data <- read.csv("workfiles/participant_45_scenario_3_s_at_2023.10.17_11.09.23.csv", sep = ";")

taskAccept_indices <- which(data$taskState == "taskAccepted")
indices_to_replace <- taskAccept_indices[4]
data$taskState[indices_to_replace] <- ""  

write.table(data, file = "workfiles/participant_45_scenario_3_s_at_2023.10.17_11.09.23.csv", sep = ";", row.names = FALSE, col.names = TRUE, quote = FALSE)

##### same as 62 s2t4
data <- read.csv("workfiles/participant_62_scenario_2_n_at_2023.10.27_16.31.15.csv", sep = ";")

taskAccept_indices <- which(data$taskState == "taskAccepted")
indices_to_replace <- taskAccept_indices[5]
data$taskState[indices_to_replace] <- ""  

write.table(data, file = "workfiles/participant_62_scenario_2_n_at_2023.10.27_16.31.15.csv", sep = ";", row.names = FALSE, col.names = TRUE, quote = FALSE)


#####  32 s1t2 there were 2 taskaccpeted with no reason 
data <- read.csv("workfiles/participant_32_scenario_1_e_at_2023.10.06_11.00.18.csv", sep = ";")

taskAccept_indices <- which(data$taskState == "taskAccepted")
indices_to_replace <- taskAccept_indices[3]
data$taskState[indices_to_replace] <- ""  

write.table(data, file = "workfiles/participant_32_scenario_1_e_at_2023.10.06_11.00.18.csv", sep = ";", row.names = FALSE, col.names = TRUE, quote = FALSE)

#####  59 s3t3 there were no tcheckedin because used F9, replace F9 with CheckedIn_migros 
data <- read.csv("workfiles/participant_59_scenario_3_e_at_2023.10.26_15.53.32.csv", sep = ";")

taskAccept_indices <- which(data$taskState == "DEBUG_IGNORE_ME: GameStart::scenario_selected.gameTasks.Count = 1")
indices_to_replace <- taskAccept_indices[1]
data$taskState[indices_to_replace] <- "checkedIn:migros"  

write.table(data, file = "workfiles/participant_59_scenario_3_e_at_2023.10.26_15.53.32.csv", sep = ";", row.names = FALSE, col.names = TRUE, quote = FALSE)

Data process:

In this part, I processed the raw data and got the new variables about the trajectory analysis.

They are about length, time, speed, stops, stop time. (Because each participant had 4 tasks each scenario, I calculate length, time, stops, stop time of separate task also the sum of them, taking into account that this makes more sense as well as to prepare for future analysis.) I will give explanations about them respectively.

Workflow:

  1. Initialize a new empty data frame to store the results and store it as a new csv file for the further analysis.
  2. Use a loop to go through each CSV file.
  3. Initialize new vectors to store length, time, stops, stop time, (speed can be calculated with length and time easily).
  4. Use task_accepted_indices and end_index to separate each task and get a subset for each task.
  5. Calculate length.
  6. Calculate time.
  7. Calculate walking stops.
  8. Calculate walking stop time.
  9. Extract the participant information from file name.
  10. Get the result.
  11. Store as new file.

Calculate length:

Calculate Euclidean distances between consecutive points in the trajectory then sum them.

Calculate time:

Extract the start time and end time for each task which is the DateTime from the first point and last point of the subset. Get time duration for each task then sum them.

Calculate walking stops:

If the coordinates are the same among consecutive points, I regard these consecutive points as a walking stop.

Calculate walking stop time:

Use stop_indices and start_indices to get the start point and end point of each walking stop. Then calculate the time of each walking stops then sum them.

## Warning: NAs introduced by coercion

## Warning: NAs introduced by coercion
##     participantno scenario startpoint      lg_1      lg_2      lg_3      lg_4
## 1              10        1          n 298.47098 175.17558  58.37155  83.92620
## 2              10        2          e 257.11124 152.57155 156.73153 320.28728
## 3              10        3          s 159.46996 309.72227  86.23219 442.84272
## 4              10        4          w 194.53284 462.81476 265.83012 256.44023
## 5              12        1          s  76.07643 201.39341 185.10973 240.73379
## 6              12        2          w 307.59492 247.82291  45.98631 344.73930
## 7              12        3          n 231.87522 280.27264 201.28460 184.82423
## 8              12        4          e 149.10454 125.24246 216.93737 177.97314
## 9              13        1          n  63.26669 230.39831 115.23920 183.16612
## 10             13        2          e 238.11275  76.50361 139.69174 126.00679
## 11             13        3          s 167.88456 102.45495  60.23065 156.86747
## 12             13        4          w 189.97557 315.14463 387.92139 178.71396
## 13             15        1          w 115.46456 122.50526 237.34840 148.59514
## 14             15        2          s 363.04987 168.80174 115.10352 308.37765
## 15             15        3          n 238.12308 310.50991  83.44824 369.42549
## 16             15        4          e 315.51542 757.23610 258.19136 264.56161
## 17             16        1          e 209.60176 216.53928 117.92258  21.88370
## 18             16        2          w 281.37010 193.81080 153.24039 264.45003
## 19             16        3          s 158.44819 100.60791  63.76827 187.60799
## 20             16        4          n  73.24566 326.30089 227.69069 172.05200
## 21             17        1          w 139.53233 369.66094 135.01212 124.13716
## 22             17        2          n 197.82430  95.80984 251.53248 182.66430
## 23             17        3          s 147.56208 113.55174 393.45519 334.41100
## 24             17        4          e 197.11181  92.75701 223.50622 336.58300
## 25             18        1          s  77.89439 167.14366 158.72800 242.35834
## 26             18        2          w 556.61989  80.76724 148.10762 222.17165
## 27             18        3          n 194.50438 206.23927 199.39442  54.05271
## 28             18        4          e 124.95173 135.93582  82.07979 137.87584
## 29             19        1          e 208.15737 307.21986  50.97791 125.98900
## 30             19        2          s 228.49116 217.02205  78.32842  40.89508
## 31             19        3          w 212.44282  69.41591 193.26054  92.56225
## 32             19        4          n  64.13484 207.62425 113.12503 210.84765
## 33             20        1          n  64.02803 247.39121 127.21542 210.37626
## 34             20        2          e 228.20905 140.06200 150.02795 160.95226
## 35             20        3          s 150.92116 117.35433 172.99514  31.43784
## 36             20        4          w 185.68552 255.48843 256.62440 149.34149
## 37             21        1          s  78.29299 181.84186 178.37927 265.22785
## 38             21        2          w 339.29899 495.22445 371.54334 208.98974
## 39             21        3          e 254.81495 243.56335 370.11748  79.03360
## 40             21        4          n  61.91210 216.79761 112.79489 129.56681
## 41             22        1          e 227.90491 377.10719  98.05496 127.23017
## 42             22        2          s 380.37193 217.07362  76.48392  49.90422
## 43             22        3          w 209.72651  69.23054 226.62524 231.69424
## 44             22        4          n  76.84593 230.93877 126.71884 137.26766
## 45             23        1          n  67.98972 218.45354 145.93111 148.64597
## 46             23        2          e 431.32283 197.54176  82.32274 167.10545
## 47             23        3          s 590.49841  83.82237  93.08029 131.92467
## 48             23        4          w 230.47803 513.65856 196.86128 192.06669
## 49             24        1          w 116.50019 327.53392 134.67796 172.24074
## 50             24        2          n 183.74019  65.07177 477.41754  56.23381
## 51             24        3          e 191.22452 181.36096  75.66692 124.03158
## 52             24        4          s  86.25271 255.73809 289.05437 157.28041
## 53             25        1          e 206.46553 212.24889  77.81900  47.12534
## 54             25        2          s 329.22042 159.84143  81.66481  41.66509
## 55             25        3          n 210.64759 261.70380 155.63418 127.09081
## 56             25        4          w 214.06584 471.19513 199.13499 164.86278
## 57             26        1          n  73.42316 252.10793 118.50398 242.54518
## 58             26        2          e 242.10390 126.60694 209.67770 272.26841
## 59             26        3          s 147.23295 359.65942  99.85757 309.14154
## 60             26        4          w 216.30487 309.29165 254.88646 217.29945
## 61             27        1          w 120.44800 169.32930 240.34184 147.03387
## 62             27        2          n 265.18308  64.76172 169.75352 179.07174
## 63             27        3          e 193.61444 152.00927  64.75666  63.43273
## 64             27        4          s  73.54576 233.90441  79.92338 126.20183
## 65             28        1          s  70.56087 191.87028  42.66132 268.77021
## 66             28        2          w 244.01623 175.05891 219.96165 200.71774
## 67             28        3          n 345.31930  59.49038  73.50245 117.15807
## 68             28        4          e 128.00997 132.52496  88.81364 139.07021
## 69             29        1          n  64.21752 236.40773 203.54952 289.97472
## 70             29        2          e 235.30613 393.61351 222.34489 121.55924
## 71             29        3          s 153.53182  98.66170  63.72583 162.46148
## 72             29        4          w 188.43561 352.46969 163.32489 148.71062
## 73             30        1          s  78.54235 136.61926 148.92535 214.20409
## 74             30        2          n 200.73725  88.00504 174.70346 162.93050
## 75             30        3          e 220.67408 208.13929  60.12513  75.14672
## 76             30        4          w 194.02309 296.84429 236.04237 188.92158
## 77             31        1          w 118.63243 137.68416 305.30260 141.93327
## 78             31        2          s 238.24804 210.99789  90.79606  58.56486
## 79             31        3          n 166.25847 264.57295 480.46630        NA
## 80             31        4          e 404.13499 162.37088 273.62953 159.70796
## 81             32        1          e 206.20529 235.48998  94.75378  25.33807
## 82             32        2          w 269.38455 244.61630  52.92138 384.56601
## 83             32        3          s 136.26284 106.81811 274.49775 169.75742
## 84             32        4          n  76.72668 198.56399 124.47062 266.87459
## 85             33        1          w 116.67704 325.66701 235.41536 159.36117
## 86             33        2          n 190.01041 192.19655 336.85368 151.58243
## 87             33        3          s 152.35329 117.36490 167.17289 149.65185
## 88             33        4          e 132.67438 125.93037 222.21303  37.06965
## 89             34        1          s  75.54377 249.86125  27.42493 231.56542
## 90             34        2          w 280.37464 182.10459 280.82215 200.23473
## 91             34        3          n 237.44848 227.73727 194.29731  45.68008
## 92             34        4          e 159.54237 267.68755  75.13360  34.68797
## 93             35        1          e 203.11907 218.78365  80.79860  25.94178
## 94             35        2          s 283.03697 147.96694  86.27829  43.39024
## 95             35        3          w 192.26261  58.74734 220.43028  96.27228
## 96             35        4          n  60.21859 181.43680 158.55001 238.81930
## 97             36        1          n  66.74408 245.19510 113.02853 187.21515
## 98             36        2          e 237.31852  79.28909 142.77244 122.19949
## 99             36        3          s 145.16294 100.48300  76.05260 167.36007
## 100            36        4          w 210.68525 274.49378 209.73050 170.24279
## 101            37        1          s  81.83867 255.71673 532.06562 410.35139
## 102            37        2          w 273.01051 464.92502 138.41897 293.60812
## 103            37        3          e 470.16767 144.48273 195.17222  56.00969
## 104            37        4          n  66.84010 228.42909 312.43499 126.35075
## 105            38        1          e 256.91610 309.34740 130.79881 330.45970
## 106            38        2          s 435.32687 377.06935 121.22490  35.57814
## 107            38        3          w 253.74152  97.51126 234.50593 587.40890
## 108            38        4          n 128.93012  86.94002 460.00770 333.21616
## 109            39        1          n  64.89651 223.48438 126.51762 182.09172
## 110            39        2          e 236.46313  83.73070 153.48908 243.33357
## 111            39        3          s 160.06260 164.67762 173.26289 180.28586
## 112            39        4          w 162.37959 275.55525 367.64455 171.54160
## 113            40        1          w 115.79542 130.82765 273.13464 197.14266
## 114            40        2          n 230.89427 122.84301 225.44384 145.91445
## 115            40        3          e 174.27522 162.75560  90.97534 104.33464
## 116            40        4          s  84.02168 264.02457  39.42696  53.22722
## 117            41        1          e 224.46283 213.75354  82.95143 249.67433
## 118            41        2          s 299.17806 139.05895  66.32200  44.25978
## 119            41        3          n 179.04989 194.20779 191.23386  51.58805
## 120            41        4          w 189.02241 344.98434 258.31357 157.85818
## 121            42        1          n  69.12124 166.81140 118.88010 174.62763
## 122            42        2          e 239.44076  79.75392 141.71202 116.60056
## 123            42        3          s 141.02346 113.62358  67.52359 163.19373
## 124            42        4          w 171.58935 284.08136 196.58319 161.83497
## 125            43        1          w 122.85028 612.45375  36.22024 102.19166
## 126            43        2          n 215.09272  90.47805 184.97721 186.80991
## 127            43        3          e 212.07038 220.65672  60.38779 107.57681
## 128            43        4          s 247.33354 169.24279  35.89752  97.94771
## 129            44        1          s  76.90581 252.92069  41.61363  56.55611
## 130            44        2          w 246.56357 168.76664 123.86773 157.79500
## 131            44        3          n 145.75989 183.11882 205.48159 170.72938
## 132            44        4          e 143.31981 131.25270  80.56447 137.21626
## 133            45        1          n  66.68224 167.74471 214.57242 258.81570
## 134            45        2          e 539.93197  95.32083  80.62449 129.75022
## 135            45        3          s 153.79596 123.34281 548.83181  93.42465
## 136            45        4          w 165.03549 327.02437 172.59262 165.44306
## 137            46        1          s  76.52923 189.12248 180.87506  79.41797
## 138            46        2          n 192.57286  74.01086 203.26862 153.32318
## 139            46        3          e 195.99592 161.90563  58.30095 113.31009
## 140            46        4          w 248.64714 471.15795 206.78805 169.18290
## 141            47        1          w 115.21466 133.42838 260.16841 150.89280
## 142            47        2          s 264.86109 185.34060  68.10385  98.65126
## 143            47        3          n 147.22773 209.12067 202.45988  45.04138
## 144            47        4          e 129.19844 130.46217  94.10359 137.14868
## 145            48        1          e 213.37181 312.15384  88.66862 158.86657
## 146            48        2          w 259.38861 525.70449 167.15763 172.96231
## 147            48        3          s 156.22897 112.96454  68.42881 278.24345
## 148            48        4          n  63.16479 370.86903  43.42376 176.48881
## 149            49        1          w 143.07719 126.63923 249.03070 149.07209
## 150            49        2          n 196.93371  75.42020 252.13102 170.59008
## 151            49        3          s 146.20556 276.22420  79.01135 191.68894
## 152            49        4          e 186.93466 132.48491 101.66143 230.24912
## 153            50        1          s  80.20656 192.83048 190.72920 235.64664
## 154            50        2          w 303.62638 213.29270 164.09230 168.79479
## 155            50        3          n 145.24671 185.66731 206.10043  52.17176
## 156            50        4          e 126.49050 126.66694  95.28227 139.30597
## 157            51        1          e 199.22777 239.12033  85.96731 248.88183
## 158            51        2          s 365.95844 388.73656 214.84913 321.66661
## 159            51        3          w 485.30300 250.58136  71.32874 366.02026
## 160            51        4          n 119.79391  88.48474 323.03401  29.49660
## 161            52        1          n  67.37663 219.27404 335.74371 153.77258
## 162            52        2          e 235.41370  86.02805 216.15605 306.10843
## 163            52        3          s 156.70188 125.24755 175.30621  56.74642
## 164            52        4          w 180.89108 325.85562 201.68089 175.47222
## 165            53        1          s  74.73453 362.42102  82.46815 120.32956
## 166            53        2          w 249.97375 176.33691 115.75398 178.91531
## 167            53        3          e 187.93114 162.08919  58.97559  74.95702
## 168            53        4          n  58.86107 180.25116 176.56948 119.98335
## 169            54        1          e 226.70691 224.06288  82.11550  24.25442
## 170            54        2          s 235.97411 192.06517 121.72346  80.07491
## 171            54        3          w 220.26139  64.85368 205.51428 160.21145
## 172            54        4          n  72.53474 200.36362 115.46594 236.19910
## 173            55        1          n  65.13617 241.55444 111.13023 150.28805
## 174            55        2          e 231.57170  75.06598 216.17786 294.77983
## 175            55        3          s 148.55986  98.86909 100.76438 153.68371
## 176            55        4          w 239.50256 480.85638 209.80646 175.16370
## 177            56        1          w 116.89652 142.22204 245.17500 118.76445
## 178            56        2          n 183.11046  78.91543 166.48627 163.31193
## 179            56        3          e 191.66127 184.54836  58.66655  71.32856
## 180            56        4          s  86.82509 221.87088  88.90660 129.75895
## 181            57        1          e 210.69491 313.10832 100.33795 165.71308
## 182            57        2          s 343.54453 152.04982  84.45000  49.54349
## 183            57        3          n 227.23629 173.31443 212.84979  51.25535
## 184            57        4          w 222.11042 337.29756 501.63170 178.83668
## 185            58        1          n  66.52579 234.94929 142.68256 148.67368
## 186            58        2          e 248.83020 103.04849 150.59532 118.46982
## 187            58        3          s 143.84925 119.31808 188.28651 110.47474
## 188            58        4          w 197.85632 282.44860 194.86852 166.43024
## 189            59        1          w 140.01218 168.87730 264.18543 164.35329
## 190            59        2          n 222.87786  77.89876 174.58096 182.42599
## 191            59        3          e 516.25113 144.04669 215.41169 128.78833
## 192            59        4          s 116.15601 223.92579 149.86224 158.41873
## 193            60        1          s  65.86185 379.70287 196.03874 129.98423
## 194            60        2          w 647.96926 122.32216 151.10322  24.89610
## 195            60        3          n 147.20454 158.87364 194.64076  44.89424
## 196            60        4          e 607.51721 158.80192 579.61633 128.85876
## 197            61        1          n  63.78947 483.07828  83.55963 135.39455
## 198            61        2          e 231.13175  81.53467 378.21138 122.46216
## 199            61        3          s 151.03606 101.07366  69.42496 319.79049
## 200            61        4          w 187.58006 291.32391 194.68772 132.53045
## 201            62        1          s  77.54181 259.31083  30.02188 244.05993
## 202            62        2          n 206.60223  94.45475 250.14339 188.75910
## 203            62        3          e 657.92769  67.66209 198.70852 126.37671
## 204            62        4          w 211.17934 507.13011 248.69095 160.94433
## 205            63        1          w 132.81463 144.69999 239.90001 164.67435
## 206            63        2          s 315.55758 156.22982  91.67977  60.63353
## 207            63        3          n 148.33289 212.15045 204.92719  48.36741
## 208            63        4          e 136.42273 124.22491 211.25485 164.57882
## 209             8        1          w 171.71018 337.47535 296.74136 189.42293
## 210             8        2          n 560.85912 115.33636 200.43569  77.46560
## 211             8        3          e 234.86104 172.28904  72.05856 102.32297
## 212             8        4          s  71.37930 337.01199 311.71227 248.08571
## 213             9        1          e 213.70050 253.27797  83.83465  26.37732
## 214             9        2          s 281.62375 160.49764  81.59201  43.50733
## 215             9        3          n 142.16410 159.83942 212.18494  56.31270
## 216             9        4          w 237.46469 496.23729 209.53552 175.53312
##     total_length duration_1 duration_2 duration_3 duration_4 total_duration
## 1       615.9443        145         68         24         40            277
## 2       886.7016        114         69         61        155            399
## 3       998.2671         79        205         62        255            601
## 4      1179.6180         87        222        119        105            533
## 5       703.3134         57        109        111        106            383
## 6       946.1434        136         98         30        163            427
## 7       898.2567        148        202        122        142            614
## 8       669.2575        103        106        102        123            434
## 9       592.0703         34        103         50         67            254
## 10      580.3149         90         45         58         54            247
## 11      487.4376         89         55         38         81            263
## 12     1071.7556         75        136        190         76            477
## 13      623.9133         93         63        104         56            316
## 14      955.3328        147         68         50        120            385
## 15     1001.5067        166        201         68        178            613
## 16     1595.5045        170        386        198        165            919
## 17      565.9473        121        113         63         37            334
## 18      892.8713        135         84        123        154            496
## 19      510.4324         88         90         45        126            349
## 20      799.2892         86        278        203        144            711
## 21      768.3426         75        152        104         81            412
## 22      727.8309        121         74        127        105            427
## 23      988.9800         74         82        322        153            631
## 24      849.9580         83         48         99        175            405
## 25      646.1244         42         75         89        103            309
## 26     1007.6664        232         47         63        115            457
## 27      654.1908        136        130        105         30            401
## 28      480.8432         63         61         46         73            243
## 29      692.3441         82        123         25         75            305
## 30      564.7367         90         96         29         20            235
## 31      567.6815        119         67        129         51            366
## 32      595.7318         37         96         56        118            307
## 33      649.0109         56        128         60        104            348
## 34      679.2513         89         59         63         69            280
## 35      472.7085         64         56         71         20            211
## 36      847.1398         79        126        120         80            405
## 37      703.7420         58        105         79        120            362
## 38     1415.0565        134        178        146         87            545
## 39      947.5294        126        119        169         52            466
## 40      521.0714         44        103         62         53            262
## 41      830.2972        146        192         63         89            490
## 42      723.8337        159        101         47         46            353
## 43      737.2765        132         61        152        147            492
## 44      571.7712         72        109         77         74            332
## 45      581.0203         42         88         56         57            243
## 46      878.2928        176         88         47         73            384
## 47      899.3257        258         68         66         70            462
## 48     1133.0646        129        232         97        120            578
## 49      750.9528         69        143         69         95            376
## 50      782.4633         85         46        207         35            373
## 51      572.2840        101         99         57         81            338
## 52      788.3256         72        137        175         89            473
## 53      543.6588         96        103         42         35            276
## 54      612.3917        138         67         39         26            270
## 55      755.0764        111        145         77         55            388
## 56     1049.2588        118        203         83         65            469
## 57      686.5802         46        110         74        128            358
## 58      850.6570        107         60        109        137            413
## 59      915.8915         79        224         64        160            527
## 60      997.7824        116        112        138        112            478
## 61      677.1530         50         87        123         54            314
## 62      678.7701        106         30         66         67            269
## 63      473.8131         88         79         52         36            255
## 64      513.5754         31        110         43         52            236
## 65      573.8627         35         73         30        107            245
## 66      839.7545         97         65         94         85            341
## 67      595.4702        167         28         38         67            300
## 68      488.4188         68         62         69         70            269
## 69      794.1495         49        149         91        175            464
## 70      972.8238        123        170        105         71            469
## 71      478.3808         92         87         48         87            314
## 72      852.9408        104        155         93         59            411
## 73      578.2910         61         72         79        106            318
## 74      626.3763        121         72        136        114            443
## 75      564.0852        143        169        108         55            475
## 76      915.8313        102        174        136         99            511
## 77      703.5525         80         86        169        102            437
## 78      598.6069        115         99         57         30            301
## 79      911.2977        143        176        251         NA            570
## 80      999.8434        275         78        159         69            581
## 81      561.7871        103        161         58         15            337
## 82      951.4882        115        101         28        188            432
## 83      687.3361         66         61        132         86            345
## 84      666.6359         51        101        118        150            420
## 85      837.1206         70        148        127        102            447
## 86      870.6431        110        109        153         86            458
## 87      586.5429        113         69         98        103            383
## 88      517.8874         87         63        114         26            290
## 89      584.3954         69        161         31        153            414
## 90      943.5361        165        105        130         96            496
## 91      705.1631        226        163        107         31            527
## 92      537.0515        109        170         56         29            364
## 93      528.6431         81         97         36         18            232
## 94      560.6724        116         64         33         17            230
## 95      567.7125         81         43        128         60            312
## 96      639.0247         41         77         97        227            442
## 97      612.1829         50        135         59        102            346
## 98      581.5795        111         54         69         61            295
## 99      489.0586         90         67         58         94            309
## 100     865.1523        103        144        111         89            447
## 101    1279.9724         57        134        318        222            731
## 102    1169.9626        132        216         69        136            553
## 103     865.8323        277        106        488         41            912
## 104     734.0549         65        166        169         64            464
## 105    1027.5220        143        149         62        140            494
## 106     969.1993        219        186         84         45            534
## 107    1173.1676        193         95        164        376            828
## 108    1009.0940         96         90        339        190            715
## 109     596.9902         32        113         64         82            291
## 110     717.0165        109         46         66        138            359
## 111     678.2890        108        109         83        109            409
## 112     977.1210         90        148        203         76            517
## 113     716.9004         52         53        155         87            347
## 114     725.0956         99         67        134         75            375
## 115     532.3408         98         88         60         71            317
## 116     440.7004         73        154         29         46            302
## 117     770.8421        120        106         81        127            434
## 118     548.8188        151        103         48         62            364
## 119     616.0796        117        131        119         59            426
## 120     950.1785        115        187        133         78            513
## 121     529.4404         38         73         60         68            239
## 122     577.5073         97         48         69         60            274
## 123     485.3644         60         69         36         81            246
## 124     814.0889         90        123        110         66            389
## 125     873.7159         58        265         26         82            431
## 126     677.3579        103         50         82         96            331
## 127     600.6917        117        201         57         76            451
## 128     550.4216        136         88         35         60            319
## 129     427.9962         78        131         36         63            308
## 130     696.9929        108         83         72         96            359
## 131     705.0897         98        112        107         82            399
## 132     492.3532        111         89         68        108            376
## 133     707.8151         43         71         90        110            314
## 134     845.6275        217         43         32         49            341
## 135     919.3952         69         65        232         48            414
## 136     830.0955         72        134         78         65            349
## 137     525.9447         38         92         82         35            247
## 138     623.1755         88         46        150         70            354
## 139     529.5126        100         87         48         59            294
## 140    1095.7760        176        242         92         79            589
## 141     659.7043         52         64        110         61            287
## 142     616.9568        104         78         38         46            266
## 143     603.8497        103        108        112         25            348
## 144     490.9129         66         55         51         61            233
## 145     773.0608         86        140         37         74            337
## 146    1125.2130        151        203         73         89            516
## 147     615.8658         80         76         29        135            320
## 148     653.9464         32        163         33         97            325
## 149     667.8192        102         85        121         67            375
## 150     695.0750         94         40        156         82            372
## 151     693.1301         85        156         45        120            406
## 152     651.3301         93         58         51        103            305
## 153     699.4129         43         92         89         96            320
## 154     849.8062        144        116         99         82            441
## 155     589.1862         97        112        102         28            339
## 156     487.7457         72         67         53         73            265
## 157     773.1972         85        110         35        100            330
## 158    1291.2107        176        167         78        193            614
## 159    1173.2334        221        171         79        287            758
## 160     560.8093         78         61        183         36            358
## 161     776.1670         46        109        174         86            415
## 162     843.7062        106         55         88        131            380
## 163     514.0021         95         68         79         40            282
## 164     883.8998        102        178        127         93            500
## 165     639.9533         72        174         89         75            410
## 166     720.9800        129         78         77         85            369
## 167     483.9529        137        121         64         91            413
## 168     535.6651         47        119        160         70            396
## 169     557.1397        114        121         44         20            299
## 170     629.8377        132        127         61         75            395
## 171     650.8408        134         30        140        117            421
## 172     624.5634         59         98         50        113            320
## 173     568.1089         39        141         62         79            321
## 174     817.5954        118         54         93        128            393
## 175     501.8770        108         81        132        106            427
## 176    1105.3291        188        260        105         89            642
## 177     623.0580         67         78        130         73            348
## 178     591.8241         83         43         67         66            259
## 179     506.2047         87        108         37         42            274
## 180     527.3615         59        105         55         64            283
## 181     789.8543        104        127         58         85            374
## 182     629.5878        166         80         47         28            321
## 183     664.6559        160         85         97         26            368
## 184    1239.8764        114        133        313        103            663
## 185     592.8313         49         96         75         60            280
## 186     620.9438         92         42         60         52            246
## 187     561.9286         65         63        105         53            286
## 188     841.6037        102        132         79         81            394
## 189     737.4282         71         84        138         91            384
## 190     657.7836        117         40         82         97            336
## 191    1004.4978        276         76        144        111            607
## 192     648.3628         93        115        110         75            393
## 193     771.5877         46        210         85         55            396
## 194     946.2907        251         49         67         16            383
## 195     545.6132         83         86        135         29            333
## 196    1474.7942        250         93        359         95            797
## 197     765.8219         36        193         44         70            343
## 198     813.3400         93         49        146         73            361
## 199     641.3252         71         60         44        148            323
## 200     806.1221         86        119        103         63            371
## 201     610.9345         64        155         19        135            373
## 202     739.9595        115         65        134        138            452
## 203    1050.6750        325         51        138         69            583
## 204    1127.9447        127        276        149        106            658
## 205     682.0890         77         66        115         82            340
## 206     624.1007        154         85         97         46            382
## 207     613.7779         94        109         99         40            342
## 208     636.4813         75         70        102         84            331
## 209     995.3498        127        172        128        157            584
## 210     954.0968        223         53         86         43            405
## 211     581.5316        109         95         47         56            307
## 212     968.1893         55        254        156        170            635
## 213     577.1904        116        148         71         33            368
## 214     567.2207        138         82         44         34            298
## 215     570.5012         90        115        178         55            438
## 216    1118.7706        185        389        130         95            799
##     total_speed num_stops_1 num_stops_2 num_stops_3 num_stops_4
## 1     2.2236257          10           3           2           4
## 2     2.2223098           5           6           1           6
## 3     1.6610102           4          14           5          27
## 4     2.2131669           7          20           4           4
## 5     1.8363273           2           6           6           2
## 6     2.2157926           5           9           3          10
## 7     1.4629588          24          14           6          14
## 8     1.5420680           5           6           7           8
## 9     2.3309855           2           4           2           2
## 10    2.3494530           5           4           5           1
## 11    1.8533750           5           9           3           6
## 12    2.2468670           8           7          13           5
## 13    1.9744093           6           2           3           4
## 14    2.4813839           6           1           2           7
## 15    1.6337793          10          12          11           6
## 16    1.7361311           8          30          26          17
## 17    1.6944531           4           5           3           8
## 18    1.8001438           6           4           6          19
## 19    1.4625569           6          10           5          15
## 20    1.1241761          11          35          30          13
## 21    1.8649091           4           1          16           7
## 22    1.7045220           8           7           7           3
## 23    1.5673217           3           6          25          13
## 24    2.0986618           9           5           4          17
## 25    2.0910175           3           3           5           5
## 26    2.2049593           8           5           2           4
## 27    1.6313984          17           7          11           3
## 28    1.9787785           7           4           1           2
## 29    2.2699808           4           7           4           5
## 30    2.4031349           4           4           2           4
## 31    1.5510424          11          15          14           5
## 32    1.9404944           3           5           4          10
## 33    1.8649739           2           5           4           8
## 34    2.4258973           5           5           4           3
## 35    2.2403245           4           2           5           3
## 36    2.0917033           6           7           9           5
## 37    1.9440386           5           2           4           6
## 38    2.5964340           2           6          10           3
## 39    2.0333248           5           2           7          11
## 40    1.9888222           9           3           2           3
## 41    1.6944841           5          12           5           2
## 42    2.0505204           4           2           5           3
## 43    1.4985295          10           9          13          11
## 44    1.7222024           7          10           7           2
## 45    2.3910302           1           4           2           2
## 46    2.2872208           4           6           5           5
## 47    1.9465925          10           4           6           5
## 48    1.9603193          11          11           5           9
## 49    1.9972149           3           6           3           3
## 50    2.0977569           2           2           9           2
## 51    1.6931479           5           7           7           9
## 52    1.6666503           4           9           7           2
## 53    1.9697781           5           2           4           4
## 54    2.2681176           4           3           4           2
## 55    1.9460731           8          13           3           4
## 56    2.2372255           9           9           6           5
## 57    1.9178219           2           6           5           8
## 58    2.0597021           3           6           8           7
## 59    1.7379345           5          20          10          17
## 60    2.0874109          13           7          40           9
## 61    2.1565383           3           6           6           4
## 62    2.5233087           3           2           2           4
## 63    1.8580906           5           5           7           3
## 64    2.1761669           2           5           5           2
## 65    2.3422966           3           4           3           4
## 66    2.4626232           1           1           5           2
## 67    1.9849006          10           4           3           5
## 68    1.8156832           4           4          13           4
## 69    1.7115291           2           3           4          11
## 70    2.0742511           5           9           5           2
## 71    1.5235058           6           9           3           7
## 72    2.0752818          12           4           6           3
## 73    1.8185253           7           4           3           5
## 74    1.4139419           6           3           8           4
## 75    1.1875478          15          10          15          12
## 76    1.7922335           9           6          11           9
## 77    1.6099599           3           5          10           7
## 78    1.9887271           3           3           5           5
## 79    1.5987679          19           9           8          NA
## 80    1.7209008          12           3           8           4
## 81    1.6670241           4           8           8           5
## 82    2.2025191           3           6           5          14
## 83    1.9922786           4           8           5           9
## 84    1.5872283           8           7           3           9
## 85    1.8727530           2           4          10           3
## 86    1.9009674           6           3           5           2
## 87    1.5314437           5           3           4           4
## 88    1.7858187           2           6          11           4
## 89    1.4115830           6           5           2           5
## 90    1.9022905           6           5           2           7
## 91    1.3380705          15          17          14           6
## 92    1.4754162          12          15           7           4
## 93    2.2786340           2           2           2           3
## 94    2.4377063           1           1           4           1
## 95    1.8195914           6           9          21           4
## 96    1.4457572           5           3           5          20
## 97    1.7693146           2           3           2           5
## 98    1.9714560           5           4           4           3
## 99    1.5827139           5           6           3           7
## 100   1.9354638          12          10           5           8
## 101   1.7509882           3           7          12           4
## 102   2.1156648           4           8           4           4
## 103   0.9493775           5           5          28           3
## 104   1.5820149           9          14           8           1
## 105   2.0800041           2           3           4           7
## 106   1.8149799          13           9           4           3
## 107   1.4168691           9          15          14          11
## 108   1.4113203          10           9          19          13
## 109   2.0515128           6           7           3           3
## 110   1.9972604           7           2           3           5
## 111   1.6584082          13          10           6          13
## 112   1.8899826          12           8          10           3
## 113   2.0659953           3           2          15           4
## 114   1.9335882           5           8           6           4
## 115   1.6793085           9           6           4           7
## 116   1.4592729          12          13           5           5
## 117   1.7761339          10           2           8          10
## 118   1.5077439           4           5           4           3
## 119   1.4461962           9          10          12           6
## 120   1.8521998           8           9           6           6
## 121   2.2152317           5           2           3           4
## 122   2.1076907           3           2           1           5
## 123   1.9730258           2           6           6           3
## 124   2.0927735           4           7           7           5
## 125   2.0271832           3           6           2           4
## 126   2.0463984           5           1           6           2
## 127   1.3319106          10          18           5           8
## 128   1.7254594           4           2           5           4
## 129   1.3895982           7           8           2           3
## 130   1.9414845           5           8           3           3
## 131   1.7671420           6           9           6           8
## 132   1.3094501           7           7           6          10
## 133   2.2541882           3           6           6           5
## 134   2.4798461           6           4           4           5
## 135   2.2207614           7           8          15           6
## 136   2.3784972           6           4           5           4
## 137   2.1293309           2           7           4           2
## 138   1.7603828           5           2           5           3
## 139   1.8010632          10           4           3           6
## 140   1.8604008           4          11           4           2
## 141   2.2986211           3           2           6           4
## 142   2.3193865           4           4           2           3
## 143   1.7352002          13          10           8           3
## 144   2.1069223           5           6           2           7
## 145   2.2939491           2           1           5           2
## 146   2.1806454           1          13           2           4
## 147   1.9245805           8           7           2           4
## 148   2.0121427           3           3           5           7
## 149   1.7808512           4           3           3           3
## 150   1.8684812           4           2           8           4
## 151   1.7072169           5          10           4          15
## 152   2.1355086           4           1           5           3
## 153   2.1856652           4           2           4           3
## 154   1.9269981           2          10           3           1
## 155   1.7380124           8           3           3           2
## 156   1.8405498           9           2           5           2
## 157   2.3430220           5           1           3           6
## 158   2.1029491           6           2           6           9
## 159   1.5478013          14          11           9          30
## 160   1.5665063           8           8          12           2
## 161   1.8702818           2           3           7           2
## 162   2.2202795           3           7           2           3
## 163   1.8227024           4           3           2           7
## 164   1.7677996          11           9           9           8
## 165   1.5608616           3           9          15           8
## 166   1.9538752           5           7           7           4
## 167   1.1717989          12           9           7          11
## 168   1.3526895           9          16          27           5
## 169   1.8633435           6           1           4           5
## 170   1.5945257           5          10           7          11
## 171   1.5459401          11           2           7           8
## 172   1.9517606           8          10           3           6
## 173   1.7698097           7          12           3           3
## 174   2.0803954           4           5           2           3
## 175   1.1753561           9           4          21          10
## 176   1.7216964          10          18           4           7
## 177   1.7903966           3           3           6           6
## 178   2.2850351           2           2           2           3
## 179   1.8474626           3           6           2           3
## 180   1.8634683           3           3           3           2
## 181   2.1119098           6           3           4           5
## 182   1.9613328           9           5           3           4
## 183   1.8061301          14           6           4           2
## 184   1.8701001          13           4          20           7
## 185   2.1172547           2           3           4           3
## 186   2.5241619           4           3           1           3
## 187   1.9647852           2           4           5           2
## 188   2.1360500           6           6           4           2
## 189   1.9203859           2           4           8           9
## 190   1.9576892           4           4           3           5
## 191   1.6548564          27           4          19           3
## 192   1.6497780          14           9          20           3
## 193   1.9484538           3          12           6           4
## 194   2.4707330           3           1           4           2
## 195   1.6384780          15           8           6           2
## 196   1.8504319          14           8          20           8
## 197   2.2327170           2           5           4           2
## 198   2.2530193           4           4           3           2
## 199   1.9855268           5           5           4           7
## 200   2.1728359           6           3           4           5
## 201   1.6378940           4           4           2           6
## 202   1.6370785           4           1           4           8
## 203   1.8021870          27           7          10           4
## 204   1.7142017          12          17          21           6
## 205   2.0061441           5           2           4          11
## 206   1.6337714          25           8           7           7
## 207   1.7946723          17           9           7           4
## 208   1.9229043           7           8           4           5
## 209   1.7043661           5           9          10          11
## 210   2.3557945           6           3           4           6
## 211   1.8942397           8           6           5           5
## 212   1.5247075           6          28           9          15
## 213   1.5684523           3           2           6           4
## 214   1.9034253           2           6           2           2
## 215   1.3025141           9           9          16          10
## 216   1.4002135          21          40          12           6
##     total_walkingstops stops_duration_1 stops_duration_2 stops_duration_3
## 1                   19           14.488            6.035            0.952
## 2                   18            0.004            0.099            0.001
## 3                   50            8.371           48.353           12.056
## 4                   35            0.765            7.657            0.010
## 5                   16           23.859           24.717           32.248
## 6                   27           19.988            0.205            0.003
## 7                   58           24.727           51.006           22.478
## 8                   26            0.205           44.273            6.688
## 9                   10           12.196           13.964            9.218
## 10                  15            0.007            0.128            0.434
## 11                  23           15.414           10.149           11.663
## 12                  33            0.548            8.040            5.189
## 13                  15           21.824            4.068           10.480
## 14                  16           11.288            0.001            0.001
## 15                  39            5.104           27.981            3.244
## 16                  81            6.891           14.525           40.881
## 17                  20            1.321           13.769            0.003
## 18                  35           19.073            1.625           48.822
## 19                  36           13.235           30.231           16.842
## 20                  89           34.899           54.113           61.627
## 21                  28           14.158           21.780           29.917
## 22                  25           15.432           22.906           20.636
## 23                  47            5.360           18.377           98.422
## 24                  35            0.520            8.927            0.012
## 25                  16           12.828           15.729           29.721
## 26                  19           27.773           13.474           12.810
## 27                  38           34.720           30.423           20.372
## 28                  14            1.138            0.008            0.003
## 29                  20            0.065            2.104            5.725
## 30                  14           10.994           15.649            0.001
## 31                  45           19.691           22.864           46.597
## 32                  22           12.385           12.289           14.255
## 33                  19           31.472           36.534           13.194
## 34                  17            0.004            0.908            3.046
## 35                  14            5.907           13.662            5.849
## 36                  27            9.187           10.234            1.028
## 37                  17           17.372           34.278           13.700
## 38                  21            8.346            0.778            2.608
## 39                  25            0.009            0.004            0.228
## 40                  17            6.605            8.964           14.087
## 41                  24            0.004            3.596            1.203
## 42                  14           19.350           16.861            1.239
## 43                  43           44.032           21.443           40.863
## 44                  26           24.826           13.526           20.154
## 45                   9           18.259            6.134            0.002
## 46                  20            0.610           10.269           13.678
## 47                  25           22.179           27.587           19.004
## 48                  36            9.535           11.739            0.637
## 49                  15           21.557           16.040           13.605
## 50                  15           21.367           23.614           23.422
## 51                  28            0.008            0.014            0.517
## 52                  22           25.128           20.890           35.990
## 53                  15            2.775           28.661            0.035
## 54                  13           22.276            8.934            6.389
## 55                  28           17.764            8.334           16.237
## 56                  29           11.589           12.271            0.213
## 57                  21           13.048            6.622           25.554
## 58                  24            0.511            0.005            0.158
## 59                  52           16.580           44.080            5.642
## 60                  69           13.213            0.013          501.631
## 61                  19            6.879           15.548           37.880
## 62                  11           13.421            5.945            7.619
## 63                  20            0.008            0.011            4.684
## 64                  14            3.621           10.446            7.358
## 65                  14            6.851            6.761            7.416
## 66                   9            8.852            0.001            2.414
## 67                  22           33.194            5.496            5.915
## 68                  25            0.008            0.006            1.283
## 69                  20           26.226           61.767           17.205
## 70                  21            0.036            3.785           12.120
## 71                  25           16.469           35.935           18.052
## 72                  25           19.395            6.465           23.652
## 73                  19           30.880           18.476           20.834
## 74                  21           33.452           29.957           50.656
## 75                  52            0.696            0.586           13.200
## 76                  35            9.610           30.879            3.471
## 77                  25           35.208           11.583           48.029
## 78                  16           22.606           19.059           11.129
## 79                  36           40.435           36.976            4.414
## 80                  27            0.100            0.252            9.003
## 81                  25            0.844           21.528            4.791
## 82                  28           17.325            2.562            4.976
## 83                  26           11.484            6.490           20.426
## 84                  27            5.183           10.598           53.375
## 85                  19           28.079           34.200            7.068
## 86                  16           36.034           36.997           25.882
## 87                  16           36.449           21.366           20.118
## 88                  23            0.004            0.021            0.051
## 89                  18           38.861           72.603           19.370
## 90                  20           46.881            0.524           20.258
## 91                  52          100.775           57.076           15.555
## 92                  38            0.020           40.063           20.251
## 93                   9            0.116            7.156            4.661
## 94                   7           15.453            3.740            1.021
## 95                  40            9.165            3.161           24.044
## 96                  33           12.646            7.741           34.809
## 97                  12           24.826           48.099           17.677
## 98                  16            0.005            0.134            0.003
## 99                  21           26.982           18.984           21.103
## 100                 35           11.283           28.545            0.156
## 101                 26           21.500           32.670           89.693
## 102                 20           28.202           20.964           17.195
## 103                 41            0.012            0.011          318.407
## 104                 32           28.980           28.450           21.236
## 105                 16            0.348           12.225            1.176
## 106                 29           27.139           24.212           18.955
## 107                 49           65.529           20.653           14.791
## 108                 51           18.700           13.071           59.157
## 109                 19            6.873           24.331           16.834
## 110                 17            0.038            0.066            2.024
## 111                 42           29.652           35.380           10.978
## 112                 33           20.299           26.739            8.606
## 113                 24            7.972            2.113           56.052
## 114                 23           12.371           15.512           27.625
## 115                 26            0.019            0.010            0.008
## 116                 35           28.726           24.464           11.064
## 117                 30            1.519           27.300            0.067
## 118                 16           25.505           47.552           23.340
## 119                 37           29.542           34.770           35.749
## 120                 29           34.362           31.467            1.462
## 121                 14            8.456           15.028           17.295
## 122                 11            0.032            0.097            0.001
## 123                 17            9.449           15.286            6.380
## 124                 23            5.393            7.592            8.298
## 125                 15           10.187            1.521            0.002
## 126                 14           25.831           16.937            0.005
## 127                 41            0.014            8.014            1.430
## 128                 15           15.829            0.002            0.008
## 129                 20           39.641           29.354           16.227
## 130                 19           20.467            0.214            5.472
## 131                 29           25.657           29.559           15.414
## 132                 30            0.018            0.064            4.940
## 133                 20           15.959            9.100           11.608
## 134                 19            8.677            2.452            1.954
## 135                 36            2.789           10.565           12.038
## 136                 19            1.987            0.008            5.775
## 137                 15            8.516           16.678           12.524
## 138                 15           17.054           18.361           44.253
## 139                 23            0.019            0.008            1.584
## 140                 21            6.691            9.548            0.162
## 141                 15           11.293           13.388            3.974
## 142                 13            8.069            7.391           10.831
## 143                 34           34.240           23.517           19.710
## 144                 20            0.010            0.878            7.631
## 145                 10            1.534           31.435            1.557
## 146                 20           31.356            4.041           14.837
## 147                 21           12.676           29.850            4.332
## 148                 18            7.807           11.395           11.868
## 149                 13           38.621           27.258           24.120
## 150                 18           19.857            8.921           49.794
## 151                 34           25.375           30.623           10.740
## 152                 13            1.105            5.177            0.014
## 153                 13           12.554           12.061           14.839
## 154                 16           33.299            1.220           17.486
## 155                 16           22.199           25.324           11.957
## 156                 18            5.281            0.003            2.613
## 157                 15            0.089           15.712            0.032
## 158                 23           25.500           32.406            0.005
## 159                 64           14.647           26.125           30.596
## 160                 30           17.184           19.986           19.637
## 161                 14           21.856           30.306           31.694
## 162                 15            0.002            0.101            0.002
## 163                 16           19.490           18.930           15.345
## 164                 37           18.863           30.145            0.986
## 165                 35           33.009           24.171           31.876
## 166                 23           29.716            1.497           10.122
## 167                 39            2.158            0.537            6.243
## 168                 57           13.702           17.381           40.996
## 169                 16            0.307           19.340            0.292
## 170                 33           36.694           43.661           15.326
## 171                 28           19.068            5.589           30.012
## 172                 27           22.169           21.946            2.894
## 173                 25            7.965           25.553           15.582
## 174                 14            0.004            0.099            0.001
## 175                 44           39.178           28.393           58.608
## 176                 39           33.130           14.675            0.055
## 177                 18           22.011           19.718           27.017
## 178                  9           16.556           10.442            7.990
## 179                 14            0.008            0.012            0.148
## 180                 11           17.753            6.777            4.347
## 181                 18            0.119           16.309            1.227
## 182                 21           35.961           11.020           12.911
## 183                 26           20.065           17.132            5.861
## 184                 44            6.544            2.108           33.289
## 185                 12           16.481            3.627           15.728
## 186                 11            0.006            0.003            0.001
## 187                 13            6.873            0.542           16.475
## 188                 18            9.514            1.062            1.057
## 189                 23           16.608            2.055           33.631
## 190                 16           11.163            2.639           17.248
## 191                 53            1.682            0.011           13.979
## 192                 46           11.404            5.346           14.569
## 193                 25           18.950           58.792           13.820
## 194                 10           25.287            3.697            3.054
## 195                 31           11.809           21.191           49.283
## 196                 50            0.589            0.396           14.468
## 197                 13           13.700           30.361            8.920
## 198                 13            0.004            0.003            0.003
## 199                 21           12.116           16.309           17.758
## 200                 18            6.325            8.913           10.308
## 201                 16           16.349           37.765            5.808
## 202                 17           20.096            0.001            0.507
## 203                 48            0.409            1.338           50.961
## 204                 56           21.366           24.869          106.784
## 205                 22           18.844           11.953           19.608
## 206                 47           35.096           21.702           44.792
## 207                 37           18.273            5.629           15.521
## 208                 24            1.757           12.604            0.010
## 209                 35           42.657            2.166            2.878
## 210                 19           23.265            9.593            1.533
## 211                 24            0.016            0.011            4.353
## 212                 58           15.424           66.733            4.640
## 213                 15            0.002           51.745            1.002
## 214                 12           28.664            9.359           15.317
## 215                 44           24.788           32.601           58.621
## 216                 79            9.547           92.073           12.294
##     stops_duration_4 total_walkingstop_duration
## 1              1.545                     23.020
## 2             13.486                     13.590
## 3             16.506                     85.286
## 4              0.004                      8.436
## 5             17.601                     98.425
## 6             17.765                     37.961
## 7             32.521                    130.732
## 8              0.020                     51.186
## 9              4.968                     40.346
## 10             8.028                      8.597
## 11            18.175                     55.401
## 12             0.056                     13.833
## 13             0.001                     36.373
## 14             0.533                     11.823
## 15             0.009                     36.338
## 16            27.567                     89.864
## 17             0.802                     15.895
## 18            32.572                    102.092
## 19            17.799                     78.107
## 20            32.310                    182.949
## 21            27.744                     93.599
## 22            28.023                     86.997
## 23            20.869                    143.028
## 24             7.545                     17.004
## 25            17.662                     75.940
## 26            33.242                     87.299
## 27             5.609                     91.124
## 28             0.563                      1.712
## 29            28.045                     35.939
## 30             2.677                     29.321
## 31            14.202                    103.354
## 32            23.576                     62.505
## 33            18.295                     99.495
## 34             4.574                      8.532
## 35             7.615                     33.033
## 36            12.694                     33.143
## 37            16.381                     81.731
## 38             6.269                     18.001
## 39             2.185                      2.426
## 40             3.295                     32.951
## 41            38.009                     42.812
## 42            23.322                     60.772
## 43            15.582                    121.920
## 44            17.423                     75.929
## 45             4.792                     29.187
## 46             1.539                     26.096
## 47             8.905                     77.675
## 48             5.817                     27.728
## 49            31.464                     82.666
## 50             5.083                     73.486
## 51            10.804                     11.343
## 52            14.406                     96.414
## 53             0.165                     31.636
## 54             9.808                     47.407
## 55             8.583                     50.918
## 56             4.653                     28.726
## 57            15.463                     60.687
## 58             1.027                      1.701
## 59            12.810                     79.112
## 60            17.901                    532.758
## 61             0.672                     60.979
## 62             3.434                     30.419
## 63             2.075                      6.778
## 64             3.013                     24.438
## 65            14.615                     35.643
## 66            12.234                     23.501
## 67             5.310                     49.915
## 68             0.009                      1.306
## 69            38.241                    143.439
## 70             0.002                     15.943
## 71            15.319                     85.775
## 72             5.900                     55.412
## 73            23.470                     93.660
## 74            48.121                    162.186
## 75             2.336                     16.818
## 76             8.170                     52.130
## 77            39.321                    134.141
## 78             1.558                     54.352
## 79                NA                     81.825
## 80             0.219                      9.574
## 81             0.824                     27.987
## 82            35.894                     60.757
## 83            13.828                     52.228
## 84            28.364                     97.520
## 85            42.356                    111.703
## 86            32.065                    130.978
## 87            28.768                    106.701
## 88             6.844                      6.920
## 89            70.661                    201.495
## 90            20.770                     88.433
## 91             9.531                    182.937
## 92             8.751                     69.085
## 93             0.063                     11.996
## 94             0.001                     20.215
## 95            25.306                     61.676
## 96            77.867                    133.063
## 97            30.804                    121.406
## 98             0.002                      0.144
## 99            16.538                     83.607
## 100            0.531                     40.515
## 101           50.954                    194.817
## 102           24.829                     91.190
## 103           11.720                    330.150
## 104            9.475                     88.141
## 105            9.396                     23.145
## 106           27.543                     97.849
## 107           17.295                    118.268
## 108           18.940                    109.868
## 109           13.577                     61.615
## 110           31.979                     34.107
## 111           23.181                     99.191
## 112            3.809                     59.453
## 113            4.947                     71.084
## 114           21.924                     77.432
## 115            2.442                      2.479
## 116            8.764                     73.018
## 117            0.228                     29.114
## 118           42.711                    139.108
## 119           28.377                    128.438
## 120           18.864                     86.155
## 121            0.434                     41.213
## 122            1.018                      1.148
## 123           13.831                     44.946
## 124            3.088                     24.371
## 125           21.032                     32.742
## 126            2.049                     44.822
## 127           22.036                     31.494
## 128            0.009                     15.848
## 129           35.598                    120.820
## 130           21.561                     47.714
## 131           13.211                     83.841
## 132            7.711                     12.733
## 133            9.162                     45.829
## 134            2.885                     15.968
## 135            4.754                     30.146
## 136            0.176                      7.946
## 137            4.148                     41.866
## 138            7.515                     87.183
## 139            6.031                      7.642
## 140            0.001                     16.402
## 141            9.146                     37.801
## 142            8.188                     34.479
## 143            6.037                     83.504
## 144            1.305                      9.824
## 145           20.370                     54.896
## 146           15.306                     65.540
## 147           22.039                     68.897
## 148           15.145                     46.215
## 149            0.130                     90.129
## 150           13.579                     92.151
## 151           24.169                     90.907
## 152            3.563                      9.859
## 153            9.652                     49.106
## 154           20.263                     72.268
## 155            0.354                     59.834
## 156            1.080                      8.977
## 157            1.708                     17.541
## 158            5.832                     63.743
## 159           65.559                    136.927
## 160           23.036                     79.843
## 161           33.668                    117.524
## 162            0.001                      0.106
## 163            3.713                     57.478
## 164           17.228                     67.222
## 165           16.682                    105.738
## 166           15.126                     56.461
## 167            6.785                     15.723
## 168           12.614                     84.693
## 169            7.077                     27.016
## 170           33.320                    129.001
## 171            4.207                     58.876
## 172            4.999                     52.008
## 173           21.098                     70.198
## 174            0.028                      0.132
## 175           36.143                    162.322
## 176            2.205                     50.065
## 177           12.344                     81.090
## 178            8.935                     43.923
## 179           10.502                     10.670
## 180           11.284                     40.161
## 181            4.106                     21.761
## 182            7.432                     67.324
## 183            3.942                     47.000
## 184           10.797                     52.738
## 185            9.203                     45.039
## 186            0.001                      0.011
## 187            0.003                     23.893
## 188           10.206                     21.839
## 189           12.325                     64.619
## 190           12.301                     43.351
## 191           15.995                     31.667
## 192           12.868                     44.187
## 193            6.794                     98.356
## 194            6.198                     38.236
## 195            6.504                     88.787
## 196           25.167                     40.620
## 197           15.104                     68.085
## 198            6.748                      6.758
## 199           18.060                     64.243
## 200            6.456                     32.002
## 201           28.023                     87.945
## 202            1.302                     21.906
## 203            0.008                     52.716
## 204            0.537                    153.556
## 205            6.577                     56.982
## 206           14.916                    116.506
## 207           12.719                     52.142
## 208            1.107                     15.478
## 209           66.589                    114.290
## 210            2.499                     36.890
## 211            8.620                     13.000
## 212           26.087                    112.884
## 213           12.524                     65.273
## 214           18.435                     71.775
## 215           18.740                    134.750
## 216            0.015                    113.929
# Load the here package
library(here)
## here() starts at /Users/monabartling/Documents/Arbeit/Projekte/FWF Schrödinger/Publications/CAVE study/cave_context_aware_mobile_maps/trajectory_analysis
# Write the resulting data frame to a CSV file in the project root directory
write.csv(result_df, file = here("trajectory_analysis.csv"), row.names = FALSE)
# Define the folder path
folder_path <- "workfiles"

# Delete the folder
unlink(folder_path, recursive = TRUE)